Model Table DATE MARKETING CAMPAIGN END

Attributes

Attribute	Description (where applicable)
Current Month Flag
Current Year Flag
End Date
End Month
End Quarter
End Week
End Year
Last 12 Months Flag
Last 24 Months Flag
Marketing Campaign End Date String	The end date of the marketing campaign.
Marketing Campaign End Month No
Marketing Campaign End Month Short
Marketing Campaign End Weekday
Marketing Campaign End Weekday No
Marketing Campaign End Year Month
Previous Month Flag
Previous Year Flag
Year (Week based)

Hierarchies

Hierarchy	Level
DateMarketingCampaignEndMFHy
	End Year
	End Quarter
	End Month
	End Date
DateMarketingCampaignEndMSHy
	End Year
	End Quarter
	End Month
DateMarketingCampaignEndWSHy
	Year (Week based)
	End Week
DateMarketingCampaignEndtWFHy
	Year (Week based)
	End Week
	End Date

USED BY MODEL(S)

Model Name

Crm

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table	DW Source view (SQL Server)	BI Access View	Referenced Information Source	Recommended Access Type
DATE MARKETING CAMPAIGN END	DIM_BI_TIME	DIM_BI_TIME_BI	DIM_BI_TIME_BI	On Line